UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UgQ2oN48y6KuwolR4eEvy9VSiWoldsgYkFzsL7xEQPE='
WHERE
key_id = '649df6a4a08d793d807902afae38eac3cbaecbcd6530a76e20e2e99dba2d8456'
AND (
token = 'UgQ2oN48y6KuwolR4eEvy9VSiWoldsgYkFzsL7xEQPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)