UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n3VhsF8y0rTfZy23uNBhP0HZpdgEo0gP7zs/kYob7dI='
WHERE
key_id = '8a47b9104c3123d8e57178b369b13ee5af1d23e43a7351544fd923aef768a67d'
AND (
token = 'n3VhsF8y0rTfZy23uNBhP0HZpdgEo0gP7zs/kYob7dI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)