UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8g5Q988zVyR46GHburBE9HA3wZ+uchuqwaHhkcBjlU='
WHERE
key_id = '4767574bfe4a99655d02e81d57b8d17ab9e0f183dc7e7b98ecddd4e74fd6585e'
AND (
token = 'W8g5Q988zVyR46GHburBE9HA3wZ+uchuqwaHhkcBjlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)