UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zlua+bGzx3sPu3mN/AVsYohSRgnTnIPwA9csgE7i/QI='
WHERE
key_id = 'c47989ea4eb21008e4c82c4eaf35710ff8c5dab4b04e3e2e2c169a4d3ad84d83'
AND (
token = 'zlua+bGzx3sPu3mN/AVsYohSRgnTnIPwA9csgE7i/QI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)