UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7rvEm7BnLdsY7YvXtQ4OHrapi1+XX5GyPCm1FNpFFsU='
WHERE
key_id = 'd1370cca6e828073f29dc901d969962f7a4ff8256248b66057035fc04f4e8270'
AND (
token = '7rvEm7BnLdsY7YvXtQ4OHrapi1+XX5GyPCm1FNpFFsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)