UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GZxL/NL7tigoYcWq9Fq5WcVPaAZSl8WIJsykqVp7YyA='
WHERE
key_id = '071cb6c2919b3cf4b0291e3f6fb191d4cce33af60324ff78e4c5befa6538663d'
AND (
token = 'GZxL/NL7tigoYcWq9Fq5WcVPaAZSl8WIJsykqVp7YyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)