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