UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aObd1GPX2uVHH/KzmrANfy3CQvFaIdDSEH/fyDavdR8='
WHERE
key_id = '8f84537addf5589018236c66010616643b6f5cc543c4f9e0a0cbc2c08e204427'
AND (
token = 'aObd1GPX2uVHH/KzmrANfy3CQvFaIdDSEH/fyDavdR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)