UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3m9kJsgE30U2OpW6ZMX9qIpDqaj3PWmErtumyFM425c='
WHERE
key_id = 'ca1a9e3cb77fece2bfabd00b23751aff6ad0d9a7828dd311e7ec35bf849fb5ec'
AND (
token = '3m9kJsgE30U2OpW6ZMX9qIpDqaj3PWmErtumyFM425c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)