UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgC3NC+vMy3StwHj7eV/V0BfiRZFIuoz+vWWDTq4qQI='
WHERE
key_id = '6992c037e7eadbac24d150bf16306d8ea5fbaa2fe300ed3cec123062f1bf6b83'
AND (
token = 'zgC3NC+vMy3StwHj7eV/V0BfiRZFIuoz+vWWDTq4qQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)