UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '14ozWpoZwMjYRAnn5C6gR4lNkfxjvrKnWmUPZE+ODUY='
WHERE
key_id = '7e8d5e2c1c4a74f5ad4d842bb459ec944ba16b7d62d6b0ffc542bcfd72ef9423'
AND (
token = '14ozWpoZwMjYRAnn5C6gR4lNkfxjvrKnWmUPZE+ODUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)