UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EkqY5H+y8iWIKIoTxA2LbH308sI/fHyfbrxDHj/Dt58='
WHERE
key_id = '8fbecbb25eaa132e4a9f9443e2c1b0c14c14c6989254cfa4b48e01e9c027999f'
AND (
token = 'EkqY5H+y8iWIKIoTxA2LbH308sI/fHyfbrxDHj/Dt58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)