UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xOh1+bKFvi/1jZS2HQMxpkdkJhwTl9yi6ExcII//XVg='
WHERE
key_id = 'c4b1635aaef9fe203682a04d63fca529027d6c1044d43cb5afb0cfcd78c20d07'
AND (
token = 'xOh1+bKFvi/1jZS2HQMxpkdkJhwTl9yi6ExcII//XVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)