UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0LgS6xHqyi5wIe3Xt3NXRdAD2FEp7vxb92RXEbzqMvE='
WHERE
key_id = '7f494924da7251b20fb88f6da9c18397fb154efaadae97bc8d41b6f3ae3ddabf'
AND (
token = '0LgS6xHqyi5wIe3Xt3NXRdAD2FEp7vxb92RXEbzqMvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)