UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W9ERtWvxLP0t9+mLQAb2q9Bjo6m8NLxUEuFpw7YahrQ='
WHERE
key_id = 'b8d71a1ab8e541b2522b5afcc8762589f7b6e5360387e69243a36508612b2ba6'
AND (
token = 'W9ERtWvxLP0t9+mLQAb2q9Bjo6m8NLxUEuFpw7YahrQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)