UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EXqfwTzDWT0dvSw47VNSMyCWsvHuYq3O3VC03Bn7amM='
WHERE
key_id = 'e6b56e0a4f536aad95cdf1eb5d49109c4a1a1106477045b98b52a9cd1b08b8d6'
AND (
token = 'EXqfwTzDWT0dvSw47VNSMyCWsvHuYq3O3VC03Bn7amM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)