UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h9VzFoKy/Mbyns3lZhqeX42Bbhj3dKVUEBAwZtgVywM='
WHERE
key_id = 'de07c0be149d07c3d895c4038f456aa5da99fee9cae949471202eca703d56f39'
AND (
token = 'h9VzFoKy/Mbyns3lZhqeX42Bbhj3dKVUEBAwZtgVywM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)