UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'znjDxEm4xU8kB1fNHjZxgICOsE19kbEmQ0uYLFooKGM='
WHERE
key_id = '32f80056b0f4ede4b202d9677b54fa9252f06363fd5960f22455ec832495d6ba'
AND (
token = 'znjDxEm4xU8kB1fNHjZxgICOsE19kbEmQ0uYLFooKGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)