UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6q+YCU7LsFci8y7yzXeapqQkDRUH5HFRNbxrtmLfSCE='
WHERE
key_id = '1f1affc952650a46cece4c940f6bc927e83130d511a1bb7ca0374d6836ece076'
AND (
token = '6q+YCU7LsFci8y7yzXeapqQkDRUH5HFRNbxrtmLfSCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)