UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fWQhHM3rp/oUb0mHYQg1+FsOcD6N9SsN3nWgADlG1po='
WHERE
key_id = '47e593a5248533fac6122327d5f72b89f27d04bc2c49ad5b4d3cf994004f8ad9'
AND (
token = 'fWQhHM3rp/oUb0mHYQg1+FsOcD6N9SsN3nWgADlG1po='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)