UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BiMl9k1gMbMIvi+uGeYKASg7cJYbbhDx1aCDBV3IgR0='
WHERE
key_id = 'b6b065557b0e19d378be2b313250f375ef644723512f9f3c8dd017716c74e7b3'
AND (
token = 'BiMl9k1gMbMIvi+uGeYKASg7cJYbbhDx1aCDBV3IgR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)