UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHk0oKRCpiK0aEfx+UfWue+aQqKVM7ImSK5HnoXDVfs='
WHERE
key_id = '04a0ee245b33a1428b2af7b9bbe4d514ed4662d9a3ce8f1066b63d9739ed02cf'
AND (
token = 'hHk0oKRCpiK0aEfx+UfWue+aQqKVM7ImSK5HnoXDVfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)