UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l3TcJSOqNRhu0xN8VcqTq0yG4kjYr8MVwmO5gY28BzU='
WHERE
key_id = '99e2567df6fc3d48162a9020848562be07b80d6f80d215747d1f7efa220ccf22'
AND (
token = 'l3TcJSOqNRhu0xN8VcqTq0yG4kjYr8MVwmO5gY28BzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)