UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k/3buogn8otG5Yjpq+a6uUJecEDiQJuPuZLcgVY4Wls='
WHERE
key_id = 'fd6d2fef5b7a211c615ca22acac187ed05b097e6fde190a852c7393ca008a28b'
AND (
token = 'k/3buogn8otG5Yjpq+a6uUJecEDiQJuPuZLcgVY4Wls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)