UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1EzZQDooqVruS41ht3zJ0Z32o/H0rEaT+xzz0/QnxLI='
WHERE
key_id = '396fc8eca8343cc754c367c51295b58fda315bd9b93ca55c3a454f861aa87cfa'
AND (
token = '1EzZQDooqVruS41ht3zJ0Z32o/H0rEaT+xzz0/QnxLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)