UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zVbooa7uvZ+67xD234qzqEoums4gcvdSqsyTwbA+3mU='
WHERE
key_id = 'b6158554bb8e53b0259b510e30ba8b029f4d39671c04b7c1c18646fb3ec6bbf3'
AND (
token = 'zVbooa7uvZ+67xD234qzqEoums4gcvdSqsyTwbA+3mU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)