UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NhATGq+8/OfX6nyi/KoyU3JaqnamBmtbTGRBYz8APp4='
WHERE
key_id = '247231fb509e77d1bf17ce2bd2e9972e971d704932963989a2bea4897181ad45'
AND (
token = 'NhATGq+8/OfX6nyi/KoyU3JaqnamBmtbTGRBYz8APp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)