UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SXy8oVpXbRBwblJfuOEEA8F2ALR2shTmUrPTYbm4Ovg='
WHERE
key_id = '3a45a3487419cceea9b4f447132e78944e751d93b9a92e8398893c4cf7496fe9'
AND (
token = 'SXy8oVpXbRBwblJfuOEEA8F2ALR2shTmUrPTYbm4Ovg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)