UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8s8D8ELFdPKh0gsNj2JDDWf2VkkkZ38SeN5OI3zcIEk='
WHERE
key_id = 'd4f20d41d57eb4b143bd2908a7803e1176beeee9f79e18a005570130cccb6c4c'
AND (
token = '8s8D8ELFdPKh0gsNj2JDDWf2VkkkZ38SeN5OI3zcIEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)