UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zc9ThtWSLDmjP66CiLDNX7anzCPch0jMX7aumzarjP0='
WHERE
key_id = 'db78dbf81416aa43fbca8be8823e7eb4aa9d735b2ccae42653f2cd9fc808dbe2'
AND (
token = 'zc9ThtWSLDmjP66CiLDNX7anzCPch0jMX7aumzarjP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)