UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Alb8uxuFQh7I80t7m2Gn1I15Q/bWOL5/Xs4+KEgCHo='
WHERE
key_id = 'af8838600281ecec682f253d0576382b785716ddc732c92bb292ca9b2039d118'
AND (
token = '6Alb8uxuFQh7I80t7m2Gn1I15Q/bWOL5/Xs4+KEgCHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)