UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XLuuw+iBem660lfHyL/+G6Fo04OTPsvKqSG/tD+PzY='
WHERE
key_id = '6b048e50403d360594d8ad3b4580898768a5a683d03cdfbf2cf419ce8424b113'
AND (
token = '9XLuuw+iBem660lfHyL/+G6Fo04OTPsvKqSG/tD+PzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)