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