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